﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="genelayrinti.aspx.cs" Inherits="OnlineDovizOtomasyonu.genelayrinti" %>

<%@ Register assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxSplitter" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxRoundPanel" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPanel" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxGridView.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxRoundPanel" tagprefix="dx1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Webing Online Döviz Hesap Otomasyonu | Genel Ayrıntı</title>
    <link href="css/stil.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
        .style2
        {
            height: 10%;
        }
    </style>
    </head>
<body>
    <form id="form1" runat="server">
    <div class="GenelAyrintiGenelDiv">
    

    
    <table border="0" cellspacing="0" cellpadding="0" width="100%">
    	<tr>
    		<td height="100%" width="180" align="left" valign="top">
            <table cellpadding="0" cellspacing="0" width="100%">
                                        <tr>
                                            <td align="left" valign="top">
                                                <dx:ASPxRoundPanel ID="PanelSol" runat="server" HeaderText="Tarih Aralığı" 
                                                    Theme="Aqua" Width="100%" >
                                                    <PanelCollection>
                                                        <dx:PanelContent ID="PanelContent1" runat="server" SupportsDisabledAttribute="True">
                                                            <table cellpadding="0" cellspacing="0" Width="100%">
                                                                <tr>
                                                                    <td height="25">
                                                                        <dx:ASPxDateEdit ID="txtTarih1" runat="server" Theme="Aqua" Width="100%" 
                                                                            ClientInstanceName="txtTarih1" AutoPostBack="True" 
                                                                            OnDateChanged="txtTarih1_DateChanged">
                                                                        </dx:ASPxDateEdit>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td height="25">
                                                                        <dx:ASPxDateEdit ID="txtTarih2" runat="server" Theme="Aqua" Width="100%" 
                                                                            ClientInstanceName="txtTarih2" AutoPostBack="True" 
                                                                            OnDateChanged="txtTarih2_DateChanged">
                                                                        </dx:ASPxDateEdit>
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </dx:PanelContent>
                                                    </PanelCollection>
                                                </dx:ASPxRoundPanel>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <dx:ASPxRoundPanel ID="PanelSol0" runat="server" HeaderText="Müşteri Bilgileri" 
                                                    Theme="Aqua" Width="100%">
                                                    <PanelCollection>
                                                        <dx:PanelContent ID="PanelContent2" runat="server" SupportsDisabledAttribute="True">
                                                            <table cellpadding="0" cellspacing="0" Width="100%">
                                                                <tr>
                                                                    <td height="25">
                                                                    <dx:ASPxComboBox ID="txtMusteriGroup" runat="server" 
                                                        DataSourceID="sdmusterigroup" DropDownStyle="DropDown" 
                                                        EnableIncrementalFiltering="True" IncrementalFilteringMode="StartsWith" 
                                                        LoadingPanelText="Yükleniyor..." TextField="ADI" 
                                                        TextFormatString="{1}" Theme="Aqua" ValueField="ID" Width="100%" 
                                                        AutoPostBack="True" OnSelectedIndexChanged="txtMusteriGroup_SelectedIndexChanged">
                                                        <Columns>
                                                            <dx:ListBoxColumn Caption="Group Kodu" FieldName="KODU" Width="100px" />
                                                            <dx:ListBoxColumn Caption="Group Adı" FieldName="ADI" Width="200px" />
                                                        </Columns>
                                                        <%--<ValidationSettings ErrorDisplayMode="ImageWithTooltip">
                                                            <RequiredField ErrorText="Müşteri Gurubunu Seçiniz!" IsRequired="True" />
                                                        </ValidationSettings>--%>
                                                    </dx:ASPxComboBox>
                                                                        <asp:SqlDataSource ID="sdmusterigroup" runat="server" 
                                                                            ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                                                                            SelectCommand="SELECT [ID], [KODU], [ADI] FROM [WEBINGDOVIZ_TBLGROUP] ORDER BY [ID]">
                                                                        </asp:SqlDataSource>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td height="25">
                                                                        <dx:ASPxComboBox ID="txtMusteriKodu" runat="server" 
                                                        LoadingPanelText="Yükleniyor..." Theme="Aqua" Width="100%" 
                                                        DataSourceID="sdMusteriBilgileri" TextFormatString="{1}" ValueField="ID"
                                                        EnableIncrementalFiltering="True" IncrementalFilteringMode="StartsWith" 
                                                        TabIndex="1" AutoPostBack="True" OnSelectedIndexChanged="txtMusteriKodu_SelectedIndexChanged">
                                                        <Columns>
                                                            <dx:ListBoxColumn Caption="Kodu" FieldName="KODU" Width="75px" />
                                                            <dx:ListBoxColumn Caption="Müşteri Adı" FieldName="ADI" Width="150px" />
                                                        </Columns>
                                                        <%--<ValidationSettings ErrorDisplayMode="ImageWithTooltip">
                                                            <RequiredField ErrorText="Müşteri Seçiniz!" IsRequired="True" />
                                                        </ValidationSettings>--%>
                                                    </dx:ASPxComboBox>
                                                                        <asp:SqlDataSource ID="sdMusteriBilgileri" runat="server" 
                                                                            ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                                                                            SelectCommand="SELECT [ID], [KODU], [ADI], [GRUP] FROM [WEBINGDOVIZ_TBLCARI] WHERE ([GRUP] = @GRUP) ORDER BY [ADI]">
                                                                            <SelectParameters>
                                                                                <asp:ControlParameter ControlID="txtMusteriGroup" Name="GRUP" 
                                                                                    PropertyName="Value" Type="Int32" />
                                                                            </SelectParameters>
                                                                        </asp:SqlDataSource>
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </dx:PanelContent>
                                                    </PanelCollection>
                                                </dx:ASPxRoundPanel>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <dx:ASPxRoundPanel ID="PanelSol1" runat="server" HeaderText="Hesap Bilgileri" 
                                                    Theme="Aqua" Width="100%">
                                                    <PanelCollection>
                                                        <dx:PanelContent ID="PanelContent3" runat="server" SupportsDisabledAttribute="True">
                                                            <table cellpadding="0" cellspacing="0" Width="100%">
                                                                <tr>
                                                                <td width="16">
                                                                    <asp:Image ID="imgTL" runat="server" ImageUrl="~/images/icon/parabirim/tl.png" 
                                                                        ToolTip="Türk Lirası" /></td>
                                                                    <td height="22">
                                                                        <dx:ASPxTextBox ID="txtTTl" runat="server" Theme="Aqua" Width="100%" 
                                                                            Font-Bold="True" Font-Size="Large" HorizontalAlign="Right" Text="0,00">
                                                                            <BackgroundImage HorizontalPosition="left" />
                                                                        </dx:ASPxTextBox>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                <td width="16">
                                                                    <asp:Image ID="Image1" runat="server" 
                                                                        ImageUrl="~/images/icon/parabirim/dolar.png" ToolTip="Dolar" /></td>
                                                                    <td height="22">
                                                                        <dx:ASPxTextBox ID="txtTUSD" runat="server" Theme="Aqua" Width="100%" 
                                                                            Font-Bold="True" Font-Size="Large" HorizontalAlign="Right" Text="0,00">
                                                                        </dx:ASPxTextBox>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                <td width="16">
                                                                    <asp:Image ID="Image2" runat="server" 
                                                                        ImageUrl="~/images/icon/parabirim/euro.png" ToolTip="Euro" /></td>
                                                                    <td height="22">
                                                                        <dx:ASPxTextBox ID="txtTEURO" runat="server" Theme="Aqua" Width="100%" 
                                                                            Font-Bold="True" Font-Size="Large" HorizontalAlign="Right" Text="0,00">
                                                                        </dx:ASPxTextBox>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                <td width="16">
                                                                    <asp:Image ID="Image3" runat="server" 
                                                                        ImageUrl="~/images/icon/parabirim/iranian-rial.png" ToolTip="Riyal" /></td>
                                                                    <td height="22">
                                                                        <dx:ASPxTextBox ID="txtTSAR" runat="server" Theme="Aqua" Width="100%" 
                                                                            Font-Bold="True" Font-Size="Large" HorizontalAlign="Right" Text="0,00">
                                                                        </dx:ASPxTextBox>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                <td width="16">
                                                                    <asp:Image ID="Image4" runat="server" 
                                                                        ImageUrl="~/images/icon/parabirim/sry.png" ToolTip="Suriye Lirası" /></td>
                                                                    <td height="22">
                                                                        <dx:ASPxTextBox ID="txtTSRY" runat="server" Theme="Aqua" Width="100%" 
                                                                            Font-Bold="True" Font-Size="Large" HorizontalAlign="Right" Text="0,00">
                                                                        </dx:ASPxTextBox>
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </dx:PanelContent>
                                                    </PanelCollection>
                                                </dx:ASPxRoundPanel>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <dx:ASPxRoundPanel ID="PanelSol2" runat="server" HeaderText="İşlemler" 
                                                    Theme="Aqua" Width="100%">
                                                    <PanelCollection>
                                                        <dx:PanelContent ID="PanelContent4" runat="server" SupportsDisabledAttribute="True">
                                                            <table cellpadding="0" cellspacing="0" Width="100%">
                                                                <tr>
                                                                    <td height="22">
                                                                        <dx:ASPxButton ID="btnGeriDon" runat="server" Text="Hesap Defterine Dön" 
                                                                            Theme="Aqua" Width="100%" PostBackUrl="~/hesapdefteri.aspx">
                                                                        </dx:ASPxButton>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td height="22">
                                                                        <dx:ASPxButton ID="btnExcel" runat="server" Text="Excel Aktar" Theme="Aqua" 
                                                                            Width="100%" OnClick="btnExcel_Click">
                                                                        </dx:ASPxButton>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td height="22">
                                                                        <dx:ASPxButton ID="btnKapat" runat="server" Text="Kapat" Theme="Aqua" 
                                                                            Width="100%" OnClick="btnKapat_Click">
                                                                        </dx:ASPxButton>
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </dx:PanelContent>
                                                    </PanelCollection>
                                                </dx:ASPxRoundPanel>
                                            </td>
                                        </tr>
                                    </table>
            </td>
    		<td align="left" valign="top">
                <table cellpadding="0" cellspacing="0" Width="100%">
                    <tr>
                        <td align="left" valign="top">
                            <dx:ASPxRoundPanel ID="PanelAlacak" runat="server" HeaderText="Alacak Dataları" 
                                Height="250px" Theme="Aqua" Width="100%">
                                <PanelCollection>
<dx:PanelContent runat="server" SupportsDisabledAttribute="True">
    <table cellpadding="0" cellspacing="0" class="style1">
        <tr>
            <td align="left" valign="top" width="20%">
                <dx:ASPxGridView ID="listeAlacakTL" runat="server" Theme="Aqua" 
                    Width="100%" AutoGenerateColumns="False" DataSourceID="sdATL" 
                    EnableTheming="True" KeyFieldName="TARIH">
                    <Columns>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn FieldName="TARIH" ShowInCustomizationForm="True" 
                            VisibleIndex="1">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="2">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="TL" ShowInCustomizationForm="True" 
                            VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ACIKLAMA" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="4">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="5">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowDragDrop="False" AllowFocusedRow="True" 
                        AllowGroup="False" />
                    <SettingsPager>
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıtlar)" 
                            Text="Sayfa {0} İle {1} ({2} Kayıt)" />
                    </SettingsPager>
                    <Settings ShowGroupButtons="False" />
                    <SettingsText EmptyDataRow="Kayıt Yok!" />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                </dx:ASPxGridView>
                <asp:SqlDataSource ID="sdATL" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    
                    
                    SelectCommand="SELECT * FROM [VWATL] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TARIH] >= @TARIH) AND ([TARIH] <= @TARIH2)) ORDER BY [TARIH]">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                       
                        <asp:ControlParameter ControlID="PanelSol$txtTarih1" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH" PropertyName="Value" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih2" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH2" PropertyName="Value" />
                        
                       
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td align="left" valign="top" width="20%">
                <dx:ASPxGridView ID="listeAlacakUSD" runat="server" Theme="Aqua" 
                    Width="100%" AutoGenerateColumns="False" DataSourceID="sdAUSD" 
                    EnableTheming="True" KeyFieldName="TARIH">
                    <Columns>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn FieldName="TARIH" ShowInCustomizationForm="True" 
                            VisibleIndex="1">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="2">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="USD" ShowInCustomizationForm="True" 
                            VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ACIKLAMA" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="4">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="5">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowDragDrop="False" AllowFocusedRow="True" 
                        AllowGroup="False" />
                    <SettingsPager>
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıtlar)" 
                            Text="Sayfa {0} İle {1} ({2} Kayıt)" />
                    </SettingsPager>
                    <Settings ShowGroupButtons="False" />
                    <SettingsText EmptyDataRow="Kayıt Yok!" />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                </dx:ASPxGridView>
                <asp:SqlDataSource ID="sdAUSD" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    SelectCommand="SELECT * FROM [VWAUSD] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TARIH] >= @TARIH) AND ([TARIH] <= @TARIH2)) ORDER BY [TARIH]">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih1" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH" PropertyName="Value" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih2" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH2" PropertyName="Value" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td align="left" valign="top" width="20%">
                <dx:ASPxGridView ID="listeAlacakEURO" runat="server" Theme="Aqua" 
                    Width="100%" AutoGenerateColumns="False" DataSourceID="sdAEURO" 
                    EnableTheming="True" KeyFieldName="TARIH">
                    <Columns>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn FieldName="TARIH" ShowInCustomizationForm="True" 
                            VisibleIndex="1">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="2">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="EURO" ShowInCustomizationForm="True" 
                            VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ACIKLAMA" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="4">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="5">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowDragDrop="False" AllowFocusedRow="True" 
                        AllowGroup="False" />
                    <SettingsPager>
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıtlar)" 
                            Text="Sayfa {0} İle {1} ({2} Kayıt)" />
                    </SettingsPager>
                    <Settings ShowGroupButtons="False" />
                    <SettingsText EmptyDataRow="Kayıt Yok!" />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                </dx:ASPxGridView>
                <asp:SqlDataSource ID="sdAEURO" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    SelectCommand="SELECT * FROM [VWAEURO] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TARIH] >= @TARIH) AND ([TARIH] <= @TARIH2)) ORDER BY [TARIH]">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih1" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH" PropertyName="Value" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih2" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH2" PropertyName="Value" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td align="left" valign="top" width="20%">
                <dx:ASPxGridView ID="listeAlacakSAR" runat="server" Theme="Aqua" 
                    Width="100%" AutoGenerateColumns="False" DataSourceID="sdASAR" 
                    EnableTheming="True" KeyFieldName="TARIH">
                    <Columns>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn FieldName="TARIH" ShowInCustomizationForm="True" 
                            VisibleIndex="1">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="2">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="SAR" ShowInCustomizationForm="True" 
                            VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ACIKLAMA" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="4">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="5">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowDragDrop="False" AllowFocusedRow="True" 
                        AllowGroup="False" />
                    <SettingsPager>
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıtlar)" 
                            Text="Sayfa {0} İle {1} ({2} Kayıt)" />
                    </SettingsPager>
                    <Settings ShowGroupButtons="False" />
                    <SettingsText EmptyDataRow="Kayıt Yok!" />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                </dx:ASPxGridView>
                <asp:SqlDataSource ID="sdASAR" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    SelectCommand="SELECT * FROM [VWASAR] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TARIH] >= @TARIH) AND ([TARIH] <= @TARIH2)) ORDER BY [TARIH]">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih1" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH" PropertyName="Value" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih2" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH2" PropertyName="Value" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td align="left" valign="top" width="20%">
                <dx:ASPxGridView ID="listeAlacakSRY" runat="server" Theme="Aqua" 
                    Width="100%" AutoGenerateColumns="False" DataSourceID="sdASRY" 
                    EnableTheming="True" KeyFieldName="TARIH">
                    <Columns>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn FieldName="TARIH" ShowInCustomizationForm="True" 
                            VisibleIndex="1">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="2">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="SRY" ShowInCustomizationForm="True" 
                            VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ACIKLAMA" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="4">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="5">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowDragDrop="False" AllowFocusedRow="True" 
                        AllowGroup="False" />
                    <SettingsPager>
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıtlar)" 
                            Text="Sayfa {0} İle {1} ({2} Kayıt)" />
                    </SettingsPager>
                    <Settings ShowGroupButtons="False" />
                    <SettingsText EmptyDataRow="Kayıt Yok!" />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                </dx:ASPxGridView>
                <asp:SqlDataSource ID="sdASRY" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    SelectCommand="SELECT * FROM [VWASRY] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TARIH] >= @TARIH) AND ([TARIH] <= @TARIH2)) ORDER BY [TARIH]">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih1" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH" PropertyName="Value" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih2" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH2" PropertyName="Value" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>
                                    </dx:PanelContent>
</PanelCollection>
                            </dx:ASPxRoundPanel>
                        </td>
                    </tr>
                    <tr>
                        <td align="left" valign="top">
                            <dx:ASPxRoundPanel ID="PanelVeri" runat="server" HeaderText="Veri Dataları" 
                                Height="250px" Theme="Aqua" Width="100%">
                                <PanelCollection>
<dx:PanelContent runat="server" SupportsDisabledAttribute="True">
<table cellpadding="0" cellspacing="0" class="style1">
        <tr>
            <td align="left" valign="top" width="20%">
            <dx:ASPxGridView ID="listeVerecekTL" runat="server" Theme="Aqua" 
                    Width="100%" AutoGenerateColumns="False" DataSourceID="sdVTL" 
                    EnableTheming="True" KeyFieldName="TARIH">
                    <Columns>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn FieldName="TARIH" ShowInCustomizationForm="True" 
                            VisibleIndex="1">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="2">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="TL" ShowInCustomizationForm="True" 
                            VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ACIKLAMA" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="4">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="5">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowDragDrop="False" AllowFocusedRow="True" 
                        AllowGroup="False" />
                    <SettingsPager>
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıtlar)" 
                            Text="Sayfa {0} İle {1} ({2} Kayıt)" />
                    </SettingsPager>
                    <Settings ShowGroupButtons="False" />
                    <SettingsText EmptyDataRow="Kayıt Yok!" />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                </dx:ASPxGridView>
            <asp:SqlDataSource ID="sdVTL" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    SelectCommand="SELECT * FROM [VWVTL] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TARIH] >= @TARIH) AND ([TARIH] <= @TARIH2)) ORDER BY [TARIH]">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih1" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH" PropertyName="Value" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih2" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH2" PropertyName="Value" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td align="left" valign="top" width="20%">
            <dx:ASPxGridView ID="listeVerecekUSD" runat="server" Theme="Aqua" 
                    Width="100%" AutoGenerateColumns="False" DataSourceID="sdVUSD" 
                    EnableTheming="True" KeyFieldName="TARIH">
                    <Columns>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn FieldName="TARIH" ShowInCustomizationForm="True" 
                            VisibleIndex="1">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="2">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="USD" ShowInCustomizationForm="True" 
                            VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ACIKLAMA" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="4">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="5">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowDragDrop="False" AllowFocusedRow="True" 
                        AllowGroup="False" />
                    <SettingsPager>
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıtlar)" 
                            Text="Sayfa {0} İle {1} ({2} Kayıt)" />
                    </SettingsPager>
                    <Settings ShowGroupButtons="False" />
                    <SettingsText EmptyDataRow="Kayıt Yok!" />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                </dx:ASPxGridView>
            <asp:SqlDataSource ID="sdVUSD" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    SelectCommand="SELECT * FROM [VWVUSD] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TARIH] >= @TARIH) AND ([TARIH] <= @TARIH2)) ORDER BY [TARIH]">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih1" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH" PropertyName="Value" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih2" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH2" PropertyName="Value" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td align="left" valign="top" width="20%">
            <dx:ASPxGridView ID="listeVerecekEURO" runat="server" Theme="Aqua" 
                    Width="100%" AutoGenerateColumns="False" DataSourceID="sdVEURO" 
                    EnableTheming="True" KeyFieldName="TARIH">
                    <Columns>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn FieldName="TARIH" ShowInCustomizationForm="True" 
                            VisibleIndex="1">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="2">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="EURO" ShowInCustomizationForm="True" 
                            VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ACIKLAMA" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="4">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="5">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowDragDrop="False" AllowFocusedRow="True" 
                        AllowGroup="False" />
                    <SettingsPager>
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıtlar)" 
                            Text="Sayfa {0} İle {1} ({2} Kayıt)" />
                    </SettingsPager>
                    <Settings ShowGroupButtons="False" />
                    <SettingsText EmptyDataRow="Kayıt Yok!" />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                </dx:ASPxGridView>
            <asp:SqlDataSource ID="sdVEURO" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    SelectCommand="SELECT * FROM [VWVEURO] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TARIH] >= @TARIH) AND ([TARIH] <= @TARIH2)) ORDER BY [TARIH]">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih1" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH" PropertyName="Value" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih2" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH2" PropertyName="Value" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td align="left" valign="top" width="20%">
            <dx:ASPxGridView ID="listeVerecekSAR" runat="server" Theme="Aqua" 
                    Width="100%" AutoGenerateColumns="False" DataSourceID="sdVSAR" 
                    EnableTheming="True" KeyFieldName="TARIH">
                    <Columns>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn FieldName="TARIH" ShowInCustomizationForm="True" 
                            VisibleIndex="1">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="2">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="SAR" ShowInCustomizationForm="True" 
                            VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ACIKLAMA" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="4">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="5">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowDragDrop="False" AllowFocusedRow="True" 
                        AllowGroup="False" />
                    <SettingsPager>
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıtlar)" 
                            Text="Sayfa {0} İle {1} ({2} Kayıt)" />
                    </SettingsPager>
                    <Settings ShowGroupButtons="False" />
                    <SettingsText EmptyDataRow="Kayıt Yok!" />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                </dx:ASPxGridView>
            <asp:SqlDataSource ID="sdVSAR" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    SelectCommand="SELECT * FROM [VWVSAR] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TARIH] >= @TARIH) AND ([TARIH] <= @TARIH2)) ORDER BY [TARIH]">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih1" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH" PropertyName="Value" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih2" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH2" PropertyName="Value" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td align="left" valign="top" width="20%">
            <dx:ASPxGridView ID="listeVerecekSRY" runat="server" Theme="Aqua" 
                    Width="100%" AutoGenerateColumns="False" DataSourceID="sdVSRY" 
                    EnableTheming="True" KeyFieldName="TARIH">
                    <Columns>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn FieldName="TARIH" ShowInCustomizationForm="True" 
                            VisibleIndex="1">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="2">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="SRY" ShowInCustomizationForm="True" 
                            VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ACIKLAMA" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="4">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="5">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowDragDrop="False" AllowFocusedRow="True" 
                        AllowGroup="False" />
                    <SettingsPager>
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıtlar)" 
                            Text="Sayfa {0} İle {1} ({2} Kayıt)" />
                    </SettingsPager>
                    <Settings ShowGroupButtons="False" />
                    <SettingsText EmptyDataRow="Kayıt Yok!" />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                </dx:ASPxGridView>
            <asp:SqlDataSource ID="sdVSRY" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    SelectCommand="SELECT * FROM [VWVSRY] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TARIH] >= @TARIH) AND ([TARIH] <= @TARIH2)) ORDER BY [TARIH]">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih1" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH" PropertyName="Value" />
                        <asp:ControlParameter ControlID="PanelSol$txtTarih2" DbType="Date" 
                            DefaultValue="01.01.2000" Name="TARIH2" PropertyName="Value" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>
</dx:PanelContent>
</PanelCollection>
                            </dx:ASPxRoundPanel>
                        </td>
                    </tr>
                    <tr>
                        <td class="style2">
                            </td>
                    </tr>
                </table>
            </td>
    	</tr>
    </table>

    
    </div>
    </form>
</body>
</html>
